You are here: Job and Form Set Rules Reference > JDT Rules Reference > PXTrigger > Input Tables

Input Tables

State loc table

Here are the required fields for the state location table.

Field

Type

Length

Notes

Form

Char

36

 

State

Char

8

 

PolicyEffectiveDate

Char

10

CCYY-MM-DD

PolicyWrittenDate

Char

10

CCYY-MM-DD

ControllingState

Char

2

 

Location

Char

8

 

SubLocation

Char

8

 

LocationAddrDate

Char

10

CCYY-MM-DD

TransactionEffectiveDate

Char

10

CCYY-MM-DD

ProgramCd

Char

6

 

FED table

Here are the required fields for the FED table.

Field

Type

Length

Notes

FormNumber

Char

36

 

FormProcessingType

Char

1

 

EffectiveDateSourceCD

Char

2

“PE” or “PW”

EffectiveDate

Char

10

CCYY-MM-DD

WithdrawalDate

Char

10

CCYY-MM-DD